CREATE TABLE [dbo].[TMOPRC_AUDI]
(
[CO_EMPR_ORIG] [dbo].[TD_VC_002] NOT NULL,
[CO_OPRC_ORIG] [dbo].[TD_VC_003] NOT NULL,
[DE_OPRC_ORIG] [dbo].[TD_VC_050] NOT NULL,
[ST_MODI_ORIG] [dbo].[TD_VC_001_SINO] NOT NULL CONSTRAINT [DF__TMOPRC_AU__ST_MO__29221CFB] DEFAULT ('N'),
[TI_SITU_ORIG] [dbo].[TD_VC_003] NOT NULL CONSTRAINT [DF__TMOPRC_AU__TI_SI__2B0A656D] DEFAULT ('ACT'),
[CO_USCR_ORIG] [dbo].[TD_VC_008_USUA] NOT NULL,
[FE_USCR_ORIG] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TMOPRC_AU__FE_US__2CF2ADDF] DEFAULT (getdate()),
[CO_USMO_ORIG] [dbo].[TD_VC_008_USUA] NOT NULL,
[FE_USMO_ORIG] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TMOPRC_AU__FE_US__2DE6D218] DEFAULT (getdate()),
[CO_EMPR_DEST] [dbo].[TD_VC_002] NOT NULL,
[CO_OPRC_DEST] [dbo].[TD_VC_003] NOT NULL,
[DE_OPRC_DEST] [dbo].[TD_VC_050] NOT NULL,
[ST_MODI_DEST] [dbo].[TD_VC_001_SINO] NOT NULL CONSTRAINT [DF__TMOPRC_AU__ST_MO__2EDAF651] DEFAULT ('N'),
[TI_SITU_DEST] [dbo].[TD_VC_003] NOT NULL CONSTRAINT [DF__TMOPRC_AU__TI_SI__30C33EC3] DEFAULT ('ACT'),
[CO_USCR_DEST] [dbo].[TD_VC_008_USUA] NOT NULL,
[FE_USCR_DEST] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TMOPRC_AU__FE_US__32AB8735] DEFAULT (getdate()),
[CO_USMO_DEST] [dbo].[TD_VC_008_USUA] NOT NULL,
[FE_USMO_DEST] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TMOPRC_AU__FE_US__339FAB6E] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TMOPRC_AUDI] ADD CONSTRAINT [CK__TMOPRC_AU__ST_MO__2A164134] CHECK (([ST_MODI_ORIG]='N' OR [ST_MODI_ORIG]='S'))
GO
ALTER TABLE [dbo].[TMOPRC_AUDI] ADD CONSTRAINT [CK__TMOPRC_AU__ST_MO__2FCF1A8A] CHECK (([ST_MODI_DEST]='N' OR [ST_MODI_DEST]='S'))
GO
ALTER TABLE [dbo].[TMOPRC_AUDI] ADD CONSTRAINT [CK__TMOPRC_AU__TI_SI__2BFE89A6] CHECK (([TI_SITU_ORIG]='ANU' OR [TI_SITU_ORIG]='ACT'))
GO
ALTER TABLE [dbo].[TMOPRC_AUDI] ADD CONSTRAINT [CK__TMOPRC_AU__TI_SI__31B762FC] CHECK (([TI_SITU_DEST]='ANU' OR [TI_SITU_DEST]='ACT'))
GO
